Header/Footer is a relatively small macro for Excel 5.0 that allows you to change the header and footer on all selected worksheets at the same time. Why would you want to do this? I often have spreadsheets with several worksheets. It is a royal pain in the ass to open Page Setup for every worksheet in the workbook and change the headers and footers individually, so I wrote this little macro.
Instructions:
Open the file Header/Footer. A new toolbar will emerge with the header/footer icon. Select the sheets you want to change and click the button.
HELPFUL LITTLE HINTS:
• To select more than one sheet, hold down command (the open-apple) while clicking on the sheets you want to select.
• To select all sheets, hold down control, then click on the tab of any worksheet in the workbook. Select Select All Sheets from the resulting pop-up menu.
• If you want Header/Footer to load everytime you start Excel, put the file inside of the folder Excel Startup Folder (5) inside of the Preferences folder inside of the System Folder.
•Finally, Header/Footer is not an add-in; it is a hidden worksheet. I did this so you could unhide it and see what makes it tick.
Remarks:
This is a function that SHOULD be included with Excel. Why such a powerful program does not include such a simple function is beyond me.
This program is just as useful on the PC side. Simply change the name to something PC acceptable, like "ihatepcs.xls" and run it the same way. The fonts will be slightly off, but that's why I'm making a PC version...
I would like to make more helpful little macros, as well as improve this one. Any input would be appreciated greatly. In fact, e-mail me just to let me know if you use this macro at all.
To do:
Put in error-trapping. There is none to speak of right now. But since I charge no money for this thing, and since the code is readily accessible, I am in no rush to implement it.
Version history:
v2.0:
•Macro now only changes the headers and footers on SELECTED worksheets.
•Macro now has its own toolbar and icon, which it automatically displays on opening.
•The statusbar reflects the function of the macro and Microsoft's balloon-help knockoff display's the name of the macro when the mouse is positioned over the button.
v1.0:
•First stab at this macro. It changed all of the workbook's headers and footers, not just the selected sheets.
